package com.ghck.shop.dao.provider;

import com.ghck.shop.model.FlowWater;

public class FlowWaterMapperProvider {

	public String listFlowWaters(FlowWater flowWater){
		StringBuffer sb = new StringBuffer();
		sb.append(" select * from t_flow_water where user_id=#{userId}");
		if(flowWater.getType() !=null && flowWater.getType() >0 ){
			sb.append(" and type=#{type}");
		}
		sb.append(" order by create_time desc limit #{start},#{limit}");
		return sb.toString();
	}
}
